Kelly P.
Kelly P.
Reactions
-
Re: How do you make IF and IF(AND statements work together
@mleesc Sure! The YEARDAY function assigns a number, 1-365, that represents the day in the year for the Date Submitted. Your cutover is 9/30 which is day number 274. So the formula says, if the YEARD…1 · -
Re: How do you make IF and IF(AND statements work together
@mleesc Try this: =IF(YEARDAY([Date Submitted]@row) > 274, RIGHT(YEAR([Date Submitted]@row) + 1, 2), IF(YEARDAY([Date Submitted]@row) <= 274, RIGHT(YEAR([Date Submitted]@row), 2)))1 · -
Re: Workspace Panel opening automatically should be optional
I wholeheartedly agree — please STOP making the panel open! I am in Smartsheet all day every day and it's super annoying to have to repeatedly close that panel. I can easily open it myself IF I want …8 · -
Re: Search for specific words within texts
@Luiz Silva I'd probably put in a helper column with the formula below and then sum the values in that new column. =IF(CONTAINS("Day by day", [Column Name]@row), 1, 0) Hope this helps!2 · -
Re: How to count individuals in multi-contacts separately?
@afelo Try this: =COUNTIFS({Master Tracker Range 1}, "In Progress", {Master Tracker Range 2}, HAS(@cell, "Person 1")) Hope this helps!1 ·
